| |
|
|
|
This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or anywhere else a spreadsheet template is used...albeit in a web page!
FAQ
What functions are supported (Sum(),Year(), etc.)?
All functionality from the .NET System.dll framework are supported. For example:
Basic math: [c0r0]+[c0r1]
System.Math namespace: Math.Pow(1+[c1r7],2)
Strings: `[c0r1]`.Trim().Replace(`$`,``).Substring(0,1)
Dates: DateTime d=new DateTime([c1r0]);return d.Year;
Formula cell references such as `[c0r1]` are replaced by the value of the cell, then evaluated. (Note that the value of a date cell is the number of ticks.) So the above examples might look like this before being evaluated:
Basic math: 100+200
System.Math namespace: Math.Pow(1+.045,2)
Strings: `$57`.Trim().Replace(`$`,``).Substring(0,1)
Dates:DateTime d=new DateTime(632272996777884556);return d.Year;
Formula cells are created like this:
Spread1.AddCell(new FormulaCell(1,6,`[c1r4]*[c2r6]`,`Formula`,NumericFormats.ToTheDollar));
See below for more examples of how formula cells work. Note also that there are two kinds of formulas, simple and multiline. The example below shows both types of formulas.
Code used in this example
Initialization of a spreadsheet
Using Mayersoft.Web.Controls;
private void Page_Init(object sender, System.EventArgs e)
{
Spread1.LicenseKey=`eL!NJ@2H3aF`;//sample key
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
Spread1.Columns.Add(new Column(150));
Spread1.Columns.Add(new Column());
Spread1.AddCell(new Cell(0,0,`Item 1`,`Label`));
Spread1.AddCell(new Cell(0,1,`Item 2`,`Label`));
Spread1.AddCell(new Cell(0,2,`Total`,`Label`));
Spread1.AddCell(new Cell(0,3,`Div by pct`,`Label`));
Spread1.AddCell(new Cell(0,4,`Result`,`Label`));
Spread1.AddCell(new Cell(0,5,`Price |
|
|
|
NEWS
An XML error occurred on line 1: XML_ERR_NAME_REQUIRED
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » HTMLHELPER 1.0
|
| This program creates HTML help files for your programs. It collects the information that you put in into a database and when you decide to make the files, it creates the files and sends them to the required Microsoft HTML Help Compiler. You can quickly b ... |
|
| Cole Software Technologies | 1000KB | Win 95/98/ME/XP | $55.00 | Downloads: 1477 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Shorty 1.001
|
| Shorty analyses Visual Basic forms identifying duplicate shortcuts and lonely little controls that have no shortcut. When these confused or lost souls are found shortcuts are suggested, or changes in other controls that will free a suitable shortcut. ... |
|
| NaTCH Engineering | 2301KB | Win 95/98/ME/NT/2000/XP | $19.50 | Downloads: 1505 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Affiliate Creator 1.0
|
| Affiliate Creator is a shareware tool that enables shareware authors to batch build customized installers for their affiliates.You can also use it to build stand-alone applications named Self-Creator and publish them on your website so that your affiliate ... |
|
| Affiliate Creator | 1850KB | Win 98/ME/NT/2000/XP | $39.75 | Downloads: 1520 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Hotspot Builder 1.21
|
| Hotspot Builder is a tool intended for creating hotspots on graphic images used in Win- and HTML- help systems. Hotspots are special regions which can work as links to help topics, popup links and help macros when clicking on them. Hotspot Builder provide ... |
|
| Divcom Software | 885KB | Win 95/98/ME/NT/2000/XP | $46.95 | Downloads: 1430 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » DiffnMerge 1.3
|
| Quick and Easy File and Folder Comparing. With Drasbek DiffnMerge you can compare and merge files and folders. Compare two text files and see the differences in the two files side by side, then merge the text files manually or automatically by inserting t ... |
|
| Drasbek Data | 2400KB | Win 98/ME/NT/2000/XP | $29 | Downloads: 1497 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TextWiz 2.1
|
| Powerful, multi purpose utility which performs several handy functions on text,html or any type files or blocks of text from the clipboard. Includes a powerful search and replace feature which, unlike many word processors, allows you to search for and rep ... |
|
| Harmony Hollow Software | 1327KB | Windows 95/98/NT/2000 | | Downloads: 1502 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Advanced Bughound 1.1
|
| Advanced Bughound is a new bug/feature/client tracking tool. We designed Advanced Bughound to be user friendly and very easy to use. People using Advanced Bughound will feel right at home after minutes of use. While it is easy to use, it was designed to b ... |
|
| Sault Custom Programming | 3787KB | Windows 95/98/NT/2000 | $79.00 | Downloads: 1462 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MU-Trace 1.01
|
| Mu-Trace can help programmers who are working on a bigger project and are working in a group. In comparison with a standard output debugging window MU-Trace has many additional features. You can add up to 255 users and define an individual color per user. ... |
|
| Image Integration | 514k | Windows NT only | $0 | Downloads: 1376 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » II_AddIn1 1.0
|
| II_AddIn1 is the No. One Add-In for Microsoft Developer Studio, Visual C++ and Java edition. It displays function definitions or selected lines containing keywords in a separate window and jumps to the selected line. You can define individual colors per k ... |
|
| Image Integration | 433k | Windows 98/NT | $25 | Downloads: 1449 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » RTF Report Generator 1.02
|
| RTF Report Generator is a native Delphi VCL component that implements a flexible and powerful report generation engine. The result of the RTFReport is a ready-to-print editable Rich Text Format (RTF) document. In order to produce reports this engine util ... |
|
| Alexander Eltsyn | 381 Kb | Windows 95/98/NT/2000 | | Downloads: 1436 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » Extended Calendar 1.0
|
| Extended Calendar is a Delphi component that allows you to implement a customizable flat calendar. ... |
|
| Tomas Koutny | 13 Kb | Windows 95/98/NT/2000 | | Downloads: 1431 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TDotMatrix5x7 1.01
|
| TDotMatrix5x7 is a Delphi component used to draw a five by seven size dot matrix on your Delphi`s form. TDotMatrix5x7 lets you display all seven-bit ASCII characters, including alphanumeric characters (A..Z, a..z, 1..9), some Greek characters (alpha, bet ... |
|
| ADC-Soft | 125 Kb | Windows 95/98/NT/2000 | | Downloads: 1456 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TSevenSegment 2.01
|
| TSevenSegment is a Delphi component used to draw seven segment displays on your form. TSevenSegment can display: numeric values, such as `123`, `123.45`, and `1E100`; time values, such as `10:00:00`, and `12:30:45 PM`; and alphanumeric values, such as `E ... |
|
| ADC-Soft | 155 Kb | Windows 95/98/NT/2000 | | Downloads: 1328 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » XDB Engine 1.0
|
| XDB Engine is a database engine that can be also used as an universal data container. XDB Engine implements an object oriented database kernel that allows you to implement your own database look to any data in your applications. The interface hides any d ... |
|
| Tomas Koutny | 242 Kb | Windows 95/98/NT/2000 | | Downloads: 1457 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SimpleRegistry Control 2.11
|
| SimpleRegistry Control provides a simple way to access the Windows Registry from Visual Basic. This control allows you to access the Windows Registry in much more intuitive and simple way then the Win32 Registry APIs. It exposes the building blocks of th ... |
|
| Realtime Performance, Inc. | 208 Kb | Windows 95/98/NT/2000 | | Downloads: 1451 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » VB 2 Html 1.4.2
|
| VB 2 Html converts Visual Basic source code to color-coded HTML, which can be placed directly into your documentation. With VB 2 Html, your source code looks the same in a web page as it does in the Visual Basic editor, and is therefore easier to read. V ... |
|
| Planatech Solutions Ltd | 820 Kb | Windows 95/98/NT/2000 | | Downloads: 1385 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Document! VB 1.2
|
| Document! VB speeds up the process of developing HTML Help documentation for your Visual Basic project. The advanced code parser within Document! VB analyzes your source code to provide a structured set of HTML Help pages, compiled into an HTML Help file ... |
|
| Innovasys Ltd. | 4.46 MB | Windows 95/98/NT/2000 | | Downloads: 1490 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » VB DocuMentor 1.4.03
|
| VB DocuMentor is a Visual Basic add-in that lets you easily document your application as you code it. It produces formatted descriptive procedure and module headers and word wrapped comment blocks. It also inserts error trapping code and tracks your prog ... |
|
| Gridlinx Software | 526 Kb | Windows 95/98/NT/2000 | | Downloads: 1360 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » VB Builder (for Visual Basic 5) 1.3.01
|
| VB Builder (for Visual Basic 5) is a Visual Basic 5 add-in that lets you add numbers to your VB projects which aid in error trapping. By adding line numbers to your project you can add error handlers that use the VB Error Line Function. This lets you pin ... |
|
| Gridlinx Software | 487 Kb | Windows 95/98/NT/2000 | | Downloads: 1395 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Sharit 3.00.009
|
| Sharit is a tool for shareware authors to submit program listings to popular Internet shareware sites. Simply enter all your product information once and Sharit submits your new and updated listing to over 80 popular sites. ... |
|
| Trellian Australia Pty. Ltd. | 982 Kb | Windows 95/98/NT/2000 | | Downloads: 1470 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
